package com.example.demo.mapper;

import com.example.demo.bean.SEmp;

import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

public interface SEmpMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(SEmp record);
    
    List<Map<String,Object>> countEmp();

    SEmp selectByPrimaryKey(Integer id);
    
    SEmp selectByUsername(String username);
    
    
    List<SEmp> selectByDeptId(Integer deptId);
    
    //SEmp selectByRegionId(Integer id);
    
    List<SEmp> selectByTitle(String name);

    List<SEmp> selectAll();
    
    List<SEmp> selectByManageId(Integer id);

    int updateByPrimaryKey(SEmp record);
    
    List<SEmp> selectByContidion(
    		@Param("id")Integer id,
    		@Param("username")String username,
    		@Param("dept_id")Integer dept_id,
    		@Param("start")Date start,
    		@Param("end")Date end
    		);
    
    int batchDelete(int [] id);
    
    

	
}